2015-12-03 - 23408.100 - Enhancement - OSA100 Plant filter update #CrystalReportsSupport

SPECIFICATIONS

23408.100 - Add Filter On Plant to OSA100 Report

Requirement Summary

Need to add Plant filter to OSA100 Global & Regional reports.

Admin Info

Purpose	Need to add Plant filter to OSA100 Global & Regional reports.
Requested By	Jeffrey Mau
Spec Created By	Dhananjay G
Spec Created Date	12/03/2015
Spec QA by	Uday Kumar P
Objects	OSA 100 Global & Regional Reports
Document Status	Complete

Estimates

SNo	Activity	Estimation in Hours
1	Research	02
2	Documentation	02
3	Development/ Config	20
4	Unit test in DEV	04
5	Unit test in QUA	04
6	BEx Query Changes & Transports	08
	TOTAL	40

References

Prior Tickets

None

Documents

None

Spec Changes

SNo	Change Details	Requested By	Requested On	Notes if any
01	OSA100 Regional versions	Mark H/Jayson	12/21/2015	Confirmation through IM.

Functional Requirement

Purpose/WHY:

Need to add filter on Plant to OSA100 Global & Regional reports.

In Scope:

OSA100 Global & Regional BEx Queries.

Out of Scope:

Other BEx Queries.

Solution Summary

BEx Query Changes

1. Need to create an open transport request.
2. Need to add Plant Characteristic to free characteristic pane.
3. Need to collect all the BEx Query changes into transport request.

Crystal Changes
1. Need to update the report after BEx Query Changes.
2. Need to create a parameter on plant characteristic with default 'ALL' value and also give possibility to enter individual plants.
3. Need to validate the OSA100 all report versions with BEx queries after the changes.

Test Plan

Test ID	Test Scenario	Expected Results
1	Report Format.	Should be as per NEC crystal standard checklist.
2	Execute Crystal Report in Crystal Designer tool after changes.	Report should execute successfully in Crystal Designer tool.
3	Schedule the Report in NEC BI Launch Pad.	Report should execute successfully in NEC BI Launch Pad.

Solution Details

BEx Query Changes

Issues

None